package com.happyclub.paul.dao;

import com.happyclub.pojo.TbAdviceShenhe;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

/**
 * @Auther: 魏泉琦
 * @Date: 2019/4/12 17:08
 * @Description: 用户意见反馈处理中间表
 */
public interface AdviceShenheRepostirory extends JpaRepository<TbAdviceShenhe,String> {


    /**
     *@Description: 保存用户意见反馈 处理
     *@Author: 魏泉琦
     *@date: 2019/4/12
     */
    @Modifying
    @Query(value = "INSERT INTO TB_ADVICE_SHENHE(ID,ADVICE_ID,JUDGE,RESPONSE,CONTACT_WAY_SHENHE,RESPONSE_TIME) VALUES(?1,?2,?3,?4,?5,SYSDATE)",nativeQuery = true)
    Integer createAdviceShenHeMsg(String id,String adviceId,String judge,String respContent,String contactWay);

}
